FaCfpGrantOptionsConfig_Regulatory 
EntityType  Independent 
Logical Entity Name  FaCfpGrantOptionsConfig_Regulatory 
Default Table Name  FaCfpGrantOptionsConfig_Regulatory 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

FaCfpGrantOptionsConfig_Regulatory Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
FaCfpGrantOptionsConfig_RegulatoryId(PK)    CHAR(10)  NO 
 
FaYearId(FK)    CHAR(2)  NO 
 
SyCampusId(FK)    INTEGER  NO 
 
AdProgramVersionId(FK)    INTEGER  NO 
 
SchoolScholarship    CHAR(10)  YES 
 
SchoolScholarshipNA    CHAR(10)  NO 
 
StateScholarship    CHAR(10)  YES 
 
StateScholarshipNA    CHAR(10)  NO 
 
OtherScholarship    CHAR(10)  YES 
 
OtherScholarshipNA    CHAR(10)  NO 
 
EmployPaidTuition    CHAR(10)  YES 
 
EmployPaidTuitionNA    CHAR(10)  NO 
 
PellGrant    CHAR(10)  YES 
 
PellGrantNA    CHAR(10)  NO 
 
InstGrant    CHAR(10)  YES 
 
InstGrantNA    CHAR(10)  NO 
 
StateGrant    CHAR(10)  YES 
 
StateGrantNA    CHAR(10)  NO 
 
OtherGrant    CHAR(10)  YES 
 
OtherGrantNA    CHAR(10)  NO 
 
DateAdded    CHAR(10)  NO 
 
DateLstMod    CHAR(10)  NO 
 
UserId(FK)    INTEGER  NO 
 
ts    CHAR(10)  NO 
 

FaCfpGrantOptionsConfig_Regulatory Keys 
Key Name  Key Type  Keys 
PK_FaCfpGrantOptionsConfig_Regulatory_FaCfpGrantOptionsConfig_RegulatoryID  PrimaryKey  FaCfpGrantOptionsConfig_RegulatoryId 
UK_FaCfpGrantOptionsConfig_Regulatory_FaYearId_SyCampusId_AdProgramVersionId  Alternate Key  FaYearId, SyCampusId, AdProgramVersionId 

FaCfpGrantOptionsConfig_Regulatory Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
ProgramVersion  Non-Identifying  One To Zero or More        AdProgramVersionId  NO 
AwardYear  Non-Identifying  One To Zero or More        FaYearId  NO 
Campus  Non-Identifying  One To Zero or More        SyCampusId  NO 
Staff  Non-Identifying  One To Zero or More        UserId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

FaCfpGrantOptionsConfig_Regulatory Check Constraints 
Check Constraint Name  CheckConstraint 

FaCfpGrantOptionsConfig_Regulatory Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.FaCfpGrantOptionsConfig_Regulatory 
NO       
Physical (Microsoft SQL Server)
Does Not Exist 
NO       

FaCfpGrantOptionsConfig_Regulatory Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 

FaCfpGrantOptionsConfig_Regulatory Data Movement Rules 
Name  Type  Rule Text/Value